A Theory for Entity-Relationship View Updates
نویسندگان
چکیده
The traditional problem of updating relational databases through views is an important practical problem that has attracted much interest. In this paper, we examine the problem of view update in EntityRelationship based database management systems [17] where the conceptual schema is represented by a normal form ER diagram [16] and views may be modelled by ER diagrams. We develop a theory within the framework of the ER approach that characterizes the conditions under which there exist mappings from view updates into conceptual schema updates. Concepts such as virtual updates and three types of insertability are introduced.
منابع مشابه
View Update in Entity-Relationship Approach
The traditional problem of updating relational databases through views is an important practical problem that has attracted much interest. In this paper, we examine the problem of view update in Entity-Relationship based database management systems [1] where the conceptual schema is represented by a normal form ER diagram [2] and views may be modelled by ER diagrams. We develop a theory within ...
متن کاملA Conceptual Analysis of Epistemological Pre-assumptions of Floridi’s Theory of Information Ethics
Background and Aim: This paper aims at conceptual analysis of epistemological pre-assumptions of the theory of “Information Ethics” to provide better understanding about this macro-ethics theory and offer a critical standpoint about some of its pre-assumptions. Methods: A documentary method and a conceptual analysis were used. This research method and approach is best suited to explore pre-assu...
متن کاملProbabilistic Sufficiency and Algorithmic Sufficiency from the point of view of Information Theory
Given the importance of Markov chains in information theory, the definition of conditional probability for these random processes can also be defined in terms of mutual information. In this paper, the relationship between the concept of sufficiency and Markov chains from the perspective of information theory and the relationship between probabilistic sufficiency and algorithmic sufficien...
متن کاملConstant Complements, Reversibility and Universal View Updates
The algebraic specification of information systems (including databases) has been advanced by the introduction of category theoretic sketches and in particular by the authors’ Sketch Data Model (SkDM). The SkDM led to a new treatment of view updating using universal properties already studied in category theory. We call the new treatment succinctly ”universal updating”. This paper outlines the ...
متن کاملOrganizational Black Hole Theory
There are issues in organizations that require new theoretical formulation. Hence, metaphorical theorizing is used in the study of organizations to interpret them and understand their complexities. In this method, the organization is likened to an entity and one of the key features of that entity is generalized to the organization. It should be borne in mind that most organizational theories ar...
متن کامل